﻿using System.Collections.Generic;
using MyFloridaHouse.libSvDTO;

namespace MyFloridaHouse.DataAccess
{
    public partial class DAL_CensusData
    {

        /// <summary>
        /// [future] Gets the data dictionary denominators.
        /// </summary>
        /// <param name="iDataPartIDList">The i data part ID list.</param>
        /// <returns></returns>
        /// <remarks>[future] SPROC: usp_GetDataDictionaryDenominators</remarks>
        public List<DataDictionaryDenominatorDTO> GetDataDictionaryDenominators(string iDataPartIDList)
        {
            List<DataDictionaryDenominatorDTO> itemList = new List<DataDictionaryDenominatorDTO>();

            //string storedProcedureName = "usp_GetDataDictionaryDenominators";

            //using (SqlConnection db = Connect())
            //{
            //    SqlCommand StoredProcedureCommand = new SqlCommand(storedProcedureName, db);
            //    StoredProcedureCommand.CommandType = CommandType.StoredProcedure;
            //    SqlParameter dataPartIDParm = StoredProcedureCommand.Parameters.AddWithValue("iDataPartIDList", iDataPartIDList);
            //    dataPartIDParm.Direction = ParameterDirection.Input;

            //    db.Open();
            //    using (SqlDataReader rdr = StoredProcedureCommand.ExecuteReader())
            //    {
            //        while (rdr.Read())
            //        {
            //            itemList.Add(DataDictionaryDenominatorDTODataContract.DataContract(rdr));
            //        }
            //    }
            //}
            return itemList;
        }
    }
}
